package com.project.config;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;

@Configuration  
public class DruidConfiguration {
	/**
	 * 
	 * 注册一个StatViewServlet
	 * 
	 * @return
	 * 
	 */

	@Bean

	public ServletRegistrationBean DruidStatViewServle2() {

		// org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册.

		ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),
				"/druid2/*");

		// 添加初始化参数：initParams

		// 白名单：

		servletRegistrationBean.addInitParameter("allow", "127.0.0.1");

		// IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not
		// permitted to view this page.

		//servletRegistrationBean.addInitParameter("deny", "192.168.1.73");

		// 登录查看信息的账号密码.

		servletRegistrationBean.addInitParameter("loginUsername", "admin");

		servletRegistrationBean.addInitParameter("loginPassword", "123456");

		// 是否能够重置数据.

		servletRegistrationBean.addInitParameter("resetEnable", "false");

		return servletRegistrationBean;

	}

	/**
	 * 
	 * 注册一个：filterRegistrationBean
	 * 
	 * @return
	 * 
	 */

	@Bean

	public FilterRegistrationBean druidStatFilter2() {

		FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());

		// 添加过滤规则.

		filterRegistrationBean.addUrlPatterns("/*");

		// 添加不需要忽略的格式信息.

		filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid2/*");

		return filterRegistrationBean;

	}

	/**
	 * 
	 * 注册dataSouce，这里作为一个例子，只注入了部分参数信息，其它的参数自行扩散思维。
	 * 
	 * @param driver
	 * 
	 * @param url
	 * 
	 * @param username
	 * 
	 * @param password
	 * 
	 * @param maxActive
	 * 
	 * @return
	 * 
	 */

	@Bean

	public DataSource druidDataSource(@Value("${spring.datasource.driverClassName}") String driver,
			@Value("${spring.datasource.url}") String url,
			@Value("${spring.datasource.username}") String username,
			@Value("${spring.datasource.password}") String password

	) {
		DruidDataSource druidDataSource = new DruidDataSource();
		try {
			druidDataSource.setDriverClassName(driver);
			druidDataSource.setUrl(url);
			druidDataSource.setUsername(username);
			druidDataSource.setPassword(password);
			//初始化大小，最小，最大
			druidDataSource.setMaxActive(50);
			druidDataSource.setMinIdle(10);
			druidDataSource.setInitialSize(10);
			//配置获取连接等待超时的时间
			druidDataSource.setMaxWait(60000);
			//配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
			druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
			//配置一个连接在池中最小生存的时间，单位是毫秒
			druidDataSource.setMinEvictableIdleTimeMillis(300000);
			druidDataSource.setValidationQuery("SELECT 1 FROM DUAL");
			druidDataSource.setTestWhileIdle(true);
			druidDataSource.setTestOnBorrow(false);
			druidDataSource.setTestOnReturn(false);
			//打开PSCache，并且指定每个连接上PSCache的大小
			druidDataSource.setPoolPreparedStatements(true);
			druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(20);
			//配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
			druidDataSource.setFilters("stat,wall,log4j");
			//通过connectProperties属性来打开mergeSql功能；慢SQL记录
			druidDataSource.setConnectionProperties("druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000");
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		System.out.println(
				"DruidConfiguration.druidDataSource(),url=" + url + ",username=" + username + ",password=" + password);

		return druidDataSource;

	}
}
